﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ClsUtilities
{
    public class TableStruct
    {

        public enum PATIENT
        {

            PA_COD_PATIENT,
            PA_NAME,
            PA_FIRST_NAME,
            PA_MIDDLE_NAME,
            PA_LAST_NAME,
            PA_SEC_LAST_NAME,
            PA_AGENCY_COD,
            PA_DOB,
            PA_PH,
            PA_PHYSYCAL_THERAPIST,
            PA_PH_THR_ASSIST,
            PA_DX,
            PA_PHONE,
            PA_ADDRES,
            PA_OCCUPATION,
            PA_MAIL,
            PA_CREATE_DATE,
            PA_LAST_MANT_DATE
        }

        public enum PATIENT_DESCR_VALUES
        {

            PA_COD_PATIENT,
            PA_NAME,
            PA_FIRST_NAME,
            PA_MIDDLE_NAME,
            PA_LAST_NAME,
            PA_SEC_LAST_NAME,
            PA_AGENCY_COD,
            PA_DOB,
            PA_PH,
            PA_PHYSYCAL_THERAPIST,
            PA_PH_THR_ASSIST,
            PA_DX,
            PA_PHONE,
            PA_ADDRES,
            PA_OCCUPATION,
            PA_MAIL,
            PA_CREATE_DATE,
            PA_LAST_MANT_DATE,
            AG_NAME,
            WRK_NAME,
            WRK_NAME_AS
        }

        public enum AGENCY
        {
            AG_COD_AGENCY,
            AG_NAME,
            AG_PHONE,
            AG_ADDRESS,
            AG_STATUS,
            AG_CREATE_DATE,
            AG_LAST_MANT_DATE
        }

        public enum WORKERS
        {
            WRK_COD_WORKER,
            WRK_NAME,
            WRK_COD_POSITON,
            WRK_MAIL,
            WRK_ADDRESS,
            WRK_PHONE,
            WRK_STATUS,
            WRK_CREATE_DATE,
            WRK_LAST_MANT_DATE
        }

        public enum USERS
        {
            US_COD_USER,
            US_USER_NAME,
            US_PASSWORD,
            US_STATUS,
            US_LAST_PWD_CHANGE,
            US_CREATE_DATE,
            US_LAST_MANT_DATE
        }

        public enum POSITION
        {
            PST_COD_POSITON,
            PST_DESCR,
            PST_STATUS,
            PST_CREATE_DATE,
            PST_LAST_MANT_DATE
        }

        public enum FRECUENCY
        {
            FRC_COD_FREC,
            FRC_DESCR,
            FRC_STATUS,
            FRC_TIMES_A_WK,
            FRC_WEEKS,
            FRC_CREATE_DATE,
            FRC_LAST_MANT_DATE
        }

        public enum APPOINTMENTS
        {
            AP_COD_APPT,
            AP_COD_PATIENT,
            AP_DESCR,
            AP_PROGRAM_DATE,
            AP_PROGRAM_HOUR,
            AP_PROGRAM_DATETIME,
            AP_STATUS,
            AP_COMPLETED,
            AP_CREATE_DATE,
            AP_LAST_MANT_DATE
        }

        public enum TblInfo
        {
            PATIENT = 1,
            AGENCY = 2,
            WORKERS = 3,
            USERS = 4,
            POSITION = 5,
            FRECUENCY = 6,
            APPOINTMENTS = 7,
            THERAPIST_WORKER = 8,
            ASSITENT_WORKER = 9,
            TERAPISTA = 8,
            TERAPISTA_ASSIST = 9,
            ESTATUS = 10
        }

        public enum ESTATUS
        {
            CT_FIELD_CODE,
            CT_CODE_DESCR
        }
    }
}
